<%--
  Created by IntelliJ IDEA.
  User: lenovo
  Date: 2018/11/13
  Time: 9:46
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link href="${pageContext.request.contextPath}/statics/hplus/css/bootstrap.min.css" rel="stylesheet">
    <link href="${pageContext.request.contextPath}/statics/hplus/css/plugins/bootstrap-table/bootstrap-table.min.css" rel="stylesheet">
    <script src="${pageContext.request.contextPath}/statics/hplus/js/jquery.min.js"></script>
    <script src="${pageContext.request.contextPath}/statics/hplus/js/bootstrap.min.js"></script>
    <script src="${pageContext.request.contextPath}/statics/hplus/js/plugins/bootstrap-table/bootstrap-table.min.js"></script>
    <script src="${pageContext.request.contextPath}/statics/hplus/js/plugins/bootstrap-table/locale/bootstrap-table-zh-CN.min.js"></script>
    <script>
        function searcha() {
            //返回表格的 Options。
            var opts = $("#roletb").bootstrapTable("getOptions") ;
            var limit = opts.pageSize ;
            var offset = (opts.pageNumber-1) * limit;
            var username = $("#username").val() ;
            $.post("${pageContext.request.contextPath}/RuKuTongJi/queryByrukumx",{'id':username,'limit':limit,'offset':offset},function (data) {
                // var mydata = eval("("+data+")") ;
                //重新绑定表格数据
                $("#roletb").bootstrapTable('load',data) ;
            })
        }


        $(function () {
            $("#roletb").bootstrapTable({
                url:'${pageContext.request.contextPath}/RuKuTongJi/queryByrukumx',
                //设置每页多少条数据
                pageSize:2,
                pageList:[2,4,8,16],
                height:300,
                pageNumber:1,
                showFooter:true,
                //启用分页，但是默认情况下，是客户端分页的
                pagination:true,
                //启用服务器端分页
                sidePagination:'server',
                queryParams:function(params){
                    var temp = {  //这里的键的名字和控制器的变量名必须一直，这边改动，控制器也需要改成一样的
                        limit: params.limit,  //页面大小
                        offset: params.offset, //页码
                        id:$("#username").val()
                    };
                    return temp;
                },
                columns:[
                    {
                        field:'rukushijian',
                        title:'入库时间',
                        footerFormatter: function(value){
                            return "总计：";
                        }
                    },
                    {
                        field:'dianpu_Name',
                        title:'店铺'
                    },
                    {
                        field:'leixing_Name',
                        title:'操作类型'
                    },
                    {
                        field:'shangpin_Name',
                        title:'产品名称'
                    },
                    {
                        field:'shangpin_shoujia',
                        title:'进价',
                        formatter: function(value,row,index){
                            return row.shangpin_shoujia+"元";
                        },
                        //计算此列的值
                        footerFormatter: function(rows){
                            var zongjc = 0;
                            for (var i=0;i<rows.length;i++) {
                                zongjc += rows[i].shangpin_shoujia
                            }
                            return zongjc+"元";
                        }
                    },
                    {
                        field:'shuliang',
                        title:'数量',
                        formatter: function(value,row,index){
                            return row.shuliang+"个";
                        },
                        //计算此列的值
                        footerFormatter: function(rows){
                            var zongshu = 0;
                            for (var i=0;i<rows.length;i++) {
                                zongshu += rows[i].shuliang
                            }
                            return zongshu+"个";
                        }
                    },
                    {
                        field:'shuliang',
                        title:'库存'
                    },
                    {
                        field:'jingbane_Name',
                        title:'经办员工'
                    },
                    {
                        field:'danhao',
                        title:'单号'
                    },
                    {
                        field:'beizhu',
                        title:'备注信息'
                    }
                ]
            }) ;
        }) ;

        function toadd() {
            $("#modelId").modal("show") ;
        }

        $("#home-tab").click(function () {
            $(".panel panel-default").hide();
            $("#home").height("%100");
        })


    </script>

</head>
<body>


    <div class="panel panel-default">

        <div class="panel-body">
            <div class="row">

                <div class="col-sm-6">

                </div>
                <div class="col-sm-6">
                    <form  class="form-inline pull-right">
                        <input id="username" type="text" class="form-control">
                        <button class="btn btn-primary" onclick="searcha()" type="button"><span class="glyphicon glyphicon-search"></span>&nbsp;&nbsp;搜索</button>
                    </form>
                </div>
            </div>
            <div class="row">
                <div class="col-sm-12">
                    <table id="roletb"></table>
                </div>
            </div>
        </div>
    </div>
</body>
</html>